package com.sto.stoapp.db.constant;
/**
 * 物品类别表
 * @author Administrator
 *
 */
public interface GoodsTypeConstant extends StoBaseConstant{
	public static final String KEY = "key";
	public static final String VALUE = "value";
	public static final String TYPE = "type";
	public static final String BACKUP1 = "backup1";

	/**
	 * 物品类别表名
	 */
	public static final String GOODS_TYPE_TABLE = "goods_type_table";

	/**
	 * 创建物品类别表
	 */
	public static final String CREATE_GOODS_TYPE_TABLE = "CREATE TABLE "
			+ " if not exists "
			+ GOODS_TYPE_TABLE
			+ "("
			+ "id TEXT PRIMARY KEY "
			+ ","
			+ KEY
			+ " text"
			+ ","
			+ VALUE
			+ " text"
			+ ","
			+ TYPE
			+ " text"
			+ ","
			+ BACKUP1
			+ " text"
			+ ","
			+STATUS
			+" text "
			+","
			+ VERSION
			+ " text"
			+ ","
			+ BACKUPS_ONE
			+ " char(50)"
			+ ","
			+ BACKUPS_TWO
			+ " char(50)"
			+ ","
			+ BACKUPS_THREE + " char(50)" + ")";
}
